﻿USE [Actuals]
GO
/****** Object:  StoredProcedure [dbo].[usp_AddTechnicalTask]    Script Date: 03/04/2012 22:00:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
  
  ALTER procedure [dbo].[usp_AddTechnicalTask]    
@TechnicalTaskId as int,    
@UserStoryId as int,    
@UserStoryDescription as nvarchar(max),    
@SprintId as int,    
@Status as nvarchar(50),    
@TaskCompletedBy as nvarchar(50),    
@CodeReviewStatus as nvarchar(50),    
@CodeReviewDoneBy as nvarchar(50)    
    
as    
    
insert into TblTechnicalTask values    
(   
@SprintId ,    
@Status ,    
@TaskCompletedBy,    
@CodeReviewStatus ,    
@CodeReviewDoneBy,@UserStoryId ,    
@UserStoryDescription,null,null,null,null,0 )